table of contents
DROP AGGREGATE(7) | PostgreSQL 16.1 Documentation | DROP AGGREGATE(7) |
NAME¶
DROP_AGGREGATE - remove an aggregate function
SYNOPSIS¶
DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ] where aggregate_signature is: * | [ argmode ] [ argname ] argtype [ , ... ] | [ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [ argmode ] [ argname ] argtype [ , ... ]
DESCRIPTION¶
DROP AGGREGATE removes an existing aggregate function. To execute this command the current user must be the owner of the aggregate function.
PARAMETERS¶
IF EXISTS
name
argmode
argname
argtype
CASCADE
RESTRICT
NOTES¶
Alternative syntaxes for referencing ordered-set aggregates are described under ALTER AGGREGATE (ALTER_AGGREGATE(7)).
EXAMPLES¶
To remove the aggregate function myavg for type integer:
DROP AGGREGATE myavg(integer);
To remove the hypothetical-set aggregate function myrank, which takes an arbitrary list of ordering columns and a matching list of direct arguments:
DROP AGGREGATE myrank(VARIADIC "any" ORDER BY VARIADIC "any");
To remove multiple aggregate functions in one command:
DROP AGGREGATE myavg(integer), myavg(bigint);
COMPATIBILITY¶
There is no DROP AGGREGATE statement in the SQL standard.
SEE ALSO¶
ALTER AGGREGATE (ALTER_AGGREGATE(7)), CREATE AGGREGATE (CREATE_AGGREGATE(7))
2023 | PostgreSQL 16.1 |